package com.kim.rssreader.domain.constant;

public class RssCategoryConstant {

	public static final String TABLE_NAME = "rss_category";

	public static final String KEY = "_id"; // 逻辑主键

	public static final String CATEGORYID = "_categoryid";

	public static final String CATEGORYNAME = "_categoryname";

	public static final String CATEGORYCUSTOMER = "_categorycustomer";

	public static final String CATEGORYATTENTION = "_categoryattention";

	public static final int CATEGORY_KEY = 0;
	public static final int CATEGORY_CATEGORYID = 1;
	public static final int CATEGORY_CATEGORYNAME = 2;
	public static final int category_CATEGORYCUSTOMER = 3;
	public static final int CATEGORY_CATEGORYATTENTION = 4;

	public static final String[] COLUMNS = new String[] { KEY, CATEGORYID,
			CATEGORYNAME, CATEGORYCUSTOMER, CATEGORYATTENTION };

	public static final String SQL_CREATE = "CREATE  TABLE IF NOT EXISTS `rss_category` ("
			+ "`_id` INTEGER PRIMARY KEY AUTOINCREMENT,"
			+ "`_categoryid` VARCHAR(36) NOT NULL,"
			+ "`_categoryname` VARCHAR(45) NOT NULL,"
			+ "`_categorycustomer` INTEGER,"
			+ "`_categoryattention` INTEGER, unique(`_categoryname`) )";

}
